{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Nov 13 Calculator"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Nov 13 Calculator","index":0,"n_rows":40,"n_cols":38,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,33,7,33],[6,34,7,34],[0,0,0,32]]}
["Nov 13 Calculator"]
[null,"q1","q2a","q2b","q3","q4","q5","q6","q7","q8","q9","q10","q11","q12","q13","q14a, b","q14c","q15","q16a","q16b","q17","q18","q19","q20","q21a","q21b","q22","q23","q24","q25","q26","q27","q28",null,"q28"]
[null,"Using a Calculator","Ratio ","Easy Percentage + fractions Ao3 Questions","Probability ","Nets, Plans & Elevations","Exchange Rates","Two Way Tables","Best Buys","Sequences","Angles in Polygons","Percentages ","Index Notation","Area and Circumference of Circles","Compound Measures","Averages from Frequency Tables","Frequency Polygons","Pythagoras' Theorem","Solving Equations ","Algebraic Fractions","Drawing Quadratic Graphs","Trigonometry","Standard Form","Reverse Percentages","Expand & Factorise Quadratics","More Difficult Rearranging Formulae","Solving Quadratics Using the Formula","Stratified Sampling","Missing Length and Volume","Y=MX+ C Harder","Sine, Cosine Rules & Area of Triangles","Histograms","Proving Congruency","Sine, Cosine Rules & Area of Triangles","Histograms","Proving Congruency"]
["Max Mark",3,2,2,2,2,3,4,4,4,4,3,4,2,3,5,2,3,3,4,4,4,2,3,1,3,5,2,3,3,5,3,3]
["Class Average (%)",{"$f":"AVERAGE(B9:B40)/B4","v":0.47619047619047622},0.625,0.8392857142857143,0.7142857142857143,0.8035714285714286,0.47619047619047622,0.30357142857142855,0.36607142857142855,0.36607142857142855,0.35714285714285715,0.5714285714285714,0.375,0.6964285714285714,0.51190476190476197,0.25,0.7142857142857143,0.41666666666666669,0.46428571428571425,0.375,0.4107142857142857,0.375,0.6785714285714286,0.45238095238095238,1.5714285714285714,0.36904761904761907,0.36428571428571427,{"$f":"AVERAGE(AB9:AB40)/AB4","v":0.7321428571428571},0.5714285714285714,0.44047619047619047,{"$f":"AVERAGE(AE9:AE40)/AE4","v":0.27857142857142858},0.54761904761904756,0.47619047619047622]
["Standard Deviation",{"$f":"IF(COUNT(B9:B36)<2,\"\",STDEV(B9:B40)/B4)","v":0.34460655000918056},0.50230948111180906,0.43148261688884837,0.51690982501377081,0.47802227040723849,0.35634832254989918,0.20813482606259295,0.25893427288012238,0.22029171376481493,0.2672612419124244,0.2989300929486885,0.26787918780535985,0.49701489869400245,0.29372228501975323,0.17743021580745905,0.43945613333038497,0.28145711395501227,0.34353866225398405,0.22047927592204922,0.22785519396754911,0.24056261216234406,0.54796400453364658,0.28994515891683087,0.87891226666077016,0.33134326579600165,0.17259304675553935,{"$f":"IF(COUNT(AB9:AB36)<2,\"\",STDEV(AB9:AB40)/AB4)","v":0.48078144062639694},0.32530002431617772,0.34009888937799171,{"$f":"IF(COUNT(AE9:AE36)<2,\"\",STDEV(AE9:AE40)/AE4)","v":0.19880595947760099},0.30380692529006548,0.34460655000918056]
[null,"q1","q2a","q2b","q3","q4","q5","q6","q7","q8","q9","q10","q11","q12","q13","q14a, b","q14c","q15","q16a","q16b","q17","q18","q19","q20","q21a","q21b","q22","q23","q24","q25","q26","q27","q28","Total Marks","Grade"]
["Name"]
["Sample student 1",{"$f":"ROUND(RAND()*$B$4,0)","v":3},3,2,1,1,1,2,1,2,1,1,3,3,2,1,1,{"$f":"ROUND(RAND()*$B$4,0)","v":1},0,2,2,2,2,2,1,3,1,3,3,2,1,1,2,{"$f":"IF(AA9=\"\",\"\",SUM(B9:AD9))","v":52},{"$f":"IF(AH9=\"\",\"\",VLOOKUP(AH9,$AK$13:$AL$34,2))","v":"B2"}]
["Sample student 2",2,1,3,0,3,0,3,1,1,0,0,3,2,0,2,1,2,2,3,2,0,0,2,1,0,2,3,2,1,1,{"$f":"ROUND(RAND()*$B$4,0)","v":3},1,{"$f":"IF(AA10=\"\",\"\",SUM(B10:AD10))","v":42},{"$f":"IF(AH10=\"\",\"\",VLOOKUP(AH10,$AK$13:$AL$34,2))","v":"C1"},null,"Grade Boundaries"]
["Sample student 3",1,0,1,2,1,3,1,0,1,1,1,3,2,1,1,3,1,0,0,1,1,0,2,2,3,2,0,3,2,2,1,1,39,"C1"]
["Sample student 4",1,1,0,0,2,1,1,1,0,0,2,1,1,1,3,1,0,3,1,1,3,0,2,2,1,2,1,1,0,1,1,1,33,"C2",null,"Non- Calc"]
["Sample student 5",3,3,2,2,3,1,2,0,2,1,3,1,2,2,1,1,0,2,2,3,2,2,1,2,2,3,2,1,1,2,3,3,52,"B2",null,0,"F3"]
["Sample student 6",1,2,1,1,2,0,1,3,0,3,1,1,1,0,0,3,1,1,2,3,2,1,1,1,3,0,1,2,1,1,1,2,39,"C1",null,0,"F2"]
["Sample student 7",1,2,3,0,3,3,0,1,3,1,3,3,2,1,2,1,3,1,1,1,3,3,2,1,0,0,1,3,0,3,3,1,48,"B2",null,0,"F1"]
["Sample student 8",0,1,2,1,1,0,3,3,3,0,3,0,2,2,1,2,1,1,3,1,3,0,3,2,1,1,0,3,1,0,2,3,44,"C1",null,0,"E3"]
["Sample student 9",2,3,2,3,1,1,1,2,1,1,1,2,1,1,1,1,1,1,1,1,1,3,1,1,1,3,2,3,0,2,0,3,43,"C1",null,3.6666666666666665,"E2"]
["Sample student 10",1,2,2,2,1,3,2,0,0,0,2,0,1,2,2,2,2,2,0,3,0,2,2,2,0,3,3,2,3,1,2,0,46,"C1",null,7.333333333333333,"E1"]
["Sample student 11",0,2,1,3,1,2,1,1,2,0,2,1,2,1,1,3,1,0,1,2,1,1,2,2,0,1,2,2,1,1,2,3,39,"C1",null,15,"D3"]
["Sample student 12",1,1,2,2,3,0,1,2,1,3,3,3,1,0,1,1,1,2,3,1,2,2,1,3,1,2,1,2,3,0,1,1,49,"B2",null,14.666666666666666,"D2"]
["Sample student 13",3,2,3,1,2,2,2,2,1,1,2,1,0,3,2,1,0,2,1,3,2,1,2,2,0,2,2,2,2,0,2,3,49,"B2",null,18.333333333333332,"D1"]
["Sample student 14",3,2,2,2,0,3,1,0,1,2,2,3,0,2,0,1,3,0,1,2,1,1,0,1,0,3,0,1,3,1,2,0,40,"C1",null,30,"C3"]
["Sample student 15",3,0,0,3,2,0,1,3,0,2,1,1,0,2,2,0,2,2,1,2,1,0,1,1,1,3,2,1,1,3,2,3,38,"C1",null,28.333333333333332,"C2"]
["Sample student 16",1,1,0,1,1,1,2,2,2,2,1,1,3,2,0,{"$f":"ROUND(RAND()*$B$4,0)","v":0},1,0,2,1,0,3,0,1,0,2,1,1,1,0,0,1,33,"C2",null,34.666666666666664,"C1"]
["Sample student 17",{"$f":"ROUND(RAND()*$B$4,0)","v":1},0,2,1,1,2,0,2,2,0,1,0,2,2,0,2,1,2,2,1,1,1,2,2,1,1,1,1,0,2,{"$f":"ROUND(RAND()*$B$4,0)","v":2},2,34,"C2",null,49,"B3"]
["Sample student 18",1,1,3,2,2,1,2,1,1,2,2,1,1,2,2,3,2,1,2,2,1,2,0,3,0,1,1,1,1,2,0,0,44,"C1",null,47.666666666666664,"B2"]
["Sample student 19",0,0,2,3,1,2,0,1,1,2,1,1,1,0,2,1,2,1,2,2,1,1,2,0,3,2,3,3,3,2,3,1,43,"C1",null,54.333333333333336,"B1"]
["Sample student 20",0,1,1,0,1,1,1,2,2,3,1,1,1,1,2,0,1,3,0,1,2,0,1,2,1,2,1,2,0,1,2,1,34,"C2",null,69,"A3"]
["Sample student 21",1,3,2,1,0,2,1,2,1,2,0,1,0,1,1,1,2,3,1,2,2,3,3,3,1,1,0,3,3,0,2,2,46,"C1",null,67.333333333333329,"A2"]
["Sample student 22",2,0,1,2,2,2,1,0,2,1,2,1,2,2,2,2,1,0,1,1,1,2,1,1,1,2,2,1,1,2,3,2,39,"C1",null,73.666666666666671,"A1"]
["Sample student 23",1,1,2,1,2,1,1,2,2,1,1,3,0,3,0,1,0,3,2,0,3,0,1,1,1,1,1,1,2,1,2,0,38,"C1",null,84," A*3"]
["Sample student 24",2,0,1,0,2,3,1,0,2,3,3,2,2,3,0,2,1,2,2,0,1,3,0,2,2,3,3,0,2,2,1,0,47,"C1",null,86.666666666666671,"A*2"]
["Sample student 25",2,1,1,0,0,3,2,3,1,3,3,1,3,2,0,1,2,2,2,1,2,0,2,2,1,2,1,2,1,3,1,1,46,"C1",null,93.333333333333329,"A*1"]
["Sample student 26",3,1,2,1,3,1,0,1,3,1,2,1,0,1,2,2,1,2,2,1,1,2,0,3,2,2,2,2,1,2,1,1,45,"C1",null,100,"A*1"]
["Sample student 27",0,0,2,3,3,0,1,3,2,1,2,3,3,2,2,1,0,1,2,3,3,2,1,0,1,2,1,0,0,3,2,1,44,"C1"]
["Sample student 28",{"$f":"ROUND(RAND()*$B$4,0)","v":1},{"$f":"ROUND(RAND()*$B$4,0)","v":1},2,2,1,1,0,2,2,3,2,0,1,2,2,2,2,0,0,3,0,1,1,0,1,2,1,0,1,0,1,1,36,"C1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]